<!--

    Copyright (c) 2005, 2018 Oracle and/or its affiliates. All rights reserved.
    Portions Copyright &#169; [2017-2020] Payara Foundation and/or affiliates.

    This program and the accompanying materials are made available under the
    terms of the Eclipse Public License v. 2.0, which is available at
    http://www.eclipse.org/legal/epl-2.0.

    This Source Code may also be made available under the following Secondary
    Licenses when the conditions for such availability set forth in the
    Eclipse Public License v. 2.0 are satisfied: GNU General Public License,
    version 2 with the GNU Classpath Exception, which is available at
    https://www.gnu.org/software/classpath/license.html.

    SPDX-License-Identifier: EPL-2.0 OR GPL-2.0 WITH Classpath-exception-2.0

-->
<!-- Portions Copyright [2019] [Payara Foundation and/or its affiliates] -->

<p><a id="task-setdbaccess" name="task-setdbaccess"></a><a id="GHJDB00030" name="GHJDB00030"></a></p>

<h4><a id="sthref2" name="sthref2"></a>To Set Up Database Access</h4>
<a name="BEGIN" id="BEGIN"></a>
<p>To store, organize, and retrieve data, most applications use relational databases.</p>
<p>Payara Server includes a copy of the Java DB database and is preconfigured with the ability to access this database.</p>
<ol>
<li>
<p>Install a supported database product.</p>
</li>
<li>
<p>Install a driver supporting the JDBC API (JDBC driver) for the database.</p>
<p>Ensure that the driver you want to use to create database connections is installed on all servers on which you want to deploy the data source.</p>
</li>
<li>
<p>Ensure that the driver's JAR file is accessible to the domain's server instance.</p>
<p>See <a href="task-integratejdbcdriver.html">To Integrate a JDBC Driver</a>.</p>
</li>
<li>
<p>Create the database.</p>
<p>Usually, the application provider delivers scripts for creating and populating the database.</p>
</li>
<li>
<p>Create a connection pool for the database.</p>
<p>See <a href="task-jdbcconnectionpoolnew.html">To Create a JDBC Connection Pool</a>.</p>
</li>
<li>
<p>Create a JDBC resource that points to the connection pool.</p>
<p>See <a href="task-jdbcresourcenew.html">To Create a JDBC Resource</a>.</p>
</li>
</ol>
<a id="sthref3" name="sthref3"></a>
<h5>See Also</h5>
<ul>
<li>
<p><a href="task-integratejdbcdriver.html">To Integrate a JDBC Driver</a></p>
</li>
<li>
<p><a href="task-jdbcresourcenew.html">To Create a JDBC Resource</a></p>
</li>
<li>
<p><a href="task-jdbcresourcesedit.html">To Edit a JDBC Resource</a></p>
</li>
<li>
<p><a href="task-jdbcresourcesdelete.html">To Delete a JDBC Resource</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpoolnew.html">To Create a JDBC Connection Pool</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpooledit.html">To Edit JDBC Connection Pool General Settings</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpooladvance.html">To Edit JDBC Connection Pool Advanced Attributes</a></p>
</li>
<li>
<p><a href="task-verifyconnpoolsettings.html">To Verify Connection Pool Settings</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpoolproperty.html">To Edit JDBC Connection Pool Properties</a></p>
</li>
<li>
<p><a href="task-jdbcconnectionpooldelete.html">To Delete a JDBC Connection Pool</a></p>
</li>
</ul>


<small>Copyright &#169; 2005, 2017, Oracle and/or its affiliates. All rights reserved. <a href="docinfo.html">Legal Notices</a></small>
<small>Portions Copyright &#169; [2017-2020] Payara Foundation and/or affiliates.</small>
